In spring 2023, ChatGPT emerged—simple, honest, and responsive to questions.
Introduction to ChatGPT
ChatGPT is a chatbot that understands human language. Users ask questions, state needs, and receive answers (accurate if questions are clear and detailed).
Capabilities include:
Writing articles (narrative, expository, argumentative, practical, fiction) and mimicking styles from samples.
Crafting ad copy and poems (classical/modern).
Generating art.
Automatically Generating Code with ChatGPT
ChatGPT excels at coding. As Sections 1.1–1.3 show, users debate tool/language choices for Excel data processing. ChatGPT may end this debate: code generation turns tool selection into a prompt parameter.
Code accuracy varies by language/tool. Through testing, Python + pandas yields the highest success rate for ChatGPT-generated data analysis code.
Microsoft 365 Copilot
On November 1, 2023, Microsoft released Microsoft 365 Copilot—essentially ChatGPT. Combined with Excel’s beta Python integration, Microsoft aims to automate Excel data processing via ChatGPT-generated Python code.
Python + ChatGPT/Copilot is the future of Excel data automation.